MacWorld 1998 January

home *** CD-ROM | disk | FTP | other *** search

/ MacWorld 1998 January / Macworld (1998-01).dmg / FileMaker Pro 4 / Full FM4 Templates / Home / Family Medical Records (.txt) < prev next >

Wrap

FileMaker Pro Database | 1997-09-14 | 146KB | 875 lines

elecom.fax! s1126 1 zer.z-netz.telecom.gateway! s95 1 zer.z-netz.telecom.lan! s24 1 zer.z-netz.telecom.modem! s62 1 zer.z-netz.telecom.satellit! s31 1 zer.z-netz.umweltschutz! s20 1 zer.z-netz.verbrauchertips! s163 1 zer.z-netz.verkehr! s112 1 zer.z-netz.wissenschaft.astronomie! s6 1 zer.z-netz.wissenschaft.biologie! s4 1 z-netz.bildung.allgemein! s15 0 z-netz.bildung.schule! s178 0 z-netz.bildung.uni! s68 0 z-netz.datenschutz.allgemein! s125 0 z-netz.datenschutz.spionage! s27 0 HBAM2016AUG95 Pro 3.0 T6@dy ADVf< HBAM3016AUG95 Pro 2.0 - 2.1F! Pro 3.0 Franz App CLAIM SUBMITTED : CONDITION DATE CREATED DATE MODIFIED DATE OF INVOICE DATE OF ONSET . DIAGNOSIS FACILITY FAMILY MEMBER INS CLAIM NUM INS GROUP NUM INS PAID AMOUNT INS POLICY HLDR INS POLICY NUM INSTRUCTIONS INSURER INVOICE ID LAST LAYOUT MEDICAL NEED MEDICAL PROVIDER PATIENT AMOUNT PHONE NUMBER RECORD ID REFERRED BY RESOLUTION STATE STREET TREATMENT TREATMENT AMNT ZIP CODE A Record IDB FacilityB StreetB CityB StateB Sunday Monday Tuesday Wednesday Thursday Friday Saturday January February March April August September October November December 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 7/29/975 Description This database keeps track of all medical events in your family. Use this database to record pertinent information, such as diagnosis and instructions, to keep a medical history for each family member, and to track insurance billing and payment. How to use this solution For each medical event, record the family member, condition, and date. Then use the tabs to enter and view information for the medical provider, treatment, and insurance information. To see a medical history fo r each person in the family, run the Medical History report. How to customize this solution Create a separate file to hold information on each of the family's regular medical providers and another one for insurance carriers. Then use lookups to quickly and accurately enter information in the Medical Provider and Insurance areas. By using lookups rather than relations, each record will retain the historical data, even if the doctor moves or the insurance information changes. X1The state field should only contain 2 characters. ) = 2 ) ZIP CodeB Phone NumberB Date CreatedB Date ModifiedB Medical ProviderB Family MemberB Date of OnsetB Medical NeedB InstructionsB ResolutionB 7A TreatmentB Invoice IDB Claim SubmittedB Ins Claim NumB Treatment AmntB Ins Paid AmountB Patient AmountB InsurerB Ins Group NumB Ins Policy NumB Ins Policy HldrB CA DiagnosisB Referred ByB Date of InvoiceB FA ConditionB InfoB Last LayoutB "AiA%Form View - Medical Need and Provider A List View Medical History Information Report Menu @QA#Form View - Treatment and Diagnosis @IA!Form View - Insurance and Billing A%Form View - Medical Need and ProviderB Yesfter Noarter Yesfter Noarter Yesfter Noarter wwwwww ffffff UUUUUU DDDDDD 3333B """""" wwxwwxw ggvgvv gvwxgwghg vhgvvww fvfgfwffv eVefefe VvffVefVVefUe\ ffFdeefeefddfDeVdfEdfFdffk EUeFFEUFEUFFUeTeVFeUUdVEEk UTdUTeETeETeEUFTUTUFTUUTeK TEETEETUETUETUDUDEETUDTUE[ 4CDD4E4ET D4DD4CDDC C3C3C34C4C3CC43C "#""3"129 #11#22122"3! A List ViewB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Your Own Button Record Delete Record Record Reports View As View As Close Medical Need Date of Onset Medical Provider Referred By Phone ZIP Code Address Treatment Facility j Condition Family Member Medical Need & Provider Insurance & Billing Treatment & DiagnosisOwn Button Your Own Button Record Delete Record Record Reports View As View As Close Medical Need Date of Onset Medical Provider Referred By Phone ZIP Code Address Treatment Facility j Condition Family Member Medical Need & Provider Insurance & Billing Treatment & Diagnosis o/Enter data for Medical Provider & Family Member Medical HistoryB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Q ConditionR Medical ProviderS Family MemberT DateU Your Own ButtonV Your Own ButtonW RecordX Delete RecordY RecordZ Reports[ View As List\ View As Form] Close^ Info_2Click to see more information for a Medical record InformationB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Reports View As View As Close Resolution Instructions h Diagnosis i Treatment Medical Provider Onset Family Member n Condition Medical Need Page ## Medical History Report MenuB Your Own ButtonI ReportsJ View As ListK View As FormL CloseM InfoO5Information about the Family Medical Records solutionP Info for this Solution e Family Medical Records solutionP Info for this Solution Your Own ReportB Your Own ReportC Your Own ReportD Medical HistoryE Your Own ButtonF ReportsG View As ListH View As FormI CloseJ InfoK>Click on any of these buttons to preview the respective reportL Select a report ButtonF ReportsG View As ListH View As FormI CloseJ InfoK>Click on any of these buttons to preview the respective reportL Select a report A#Form View - Treatment and DiagnosisB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own ButtonB ReportsC View As ListD View As FormE CloseF A!Form View - Insurance and BillingB Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Your Own Button Record Delete Record Record Reports View As View As Close Resolution Instructions to Family Member d Diagnosis e Treatment g Condition Family Member Medical Need & Provider Insurance & Billing Treatment & Diagnosis l$Enter data for Treatment & Diagnosis Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Yesfter Noarter Your Own Button Your Own Button Record Delete Record Record Reports View As View As Close Patient Amount: Paid by Insurance: Total Amount: Invoice ID Invoice Date Billing Claim Number Policy Holder Group Number Policy Number Insurer h Insurance j Condition Family Member Medical Need & Providerur Own Button Your Own Button Record Delete Record Record Reports View As View As Close Patient Amount: Paid by Insurance: Total Amount: Invoice ID Invoice Date Billing Claim Number Policy Holder Group Number Policy Number Insurer h Insurance j Condition Family Member Medical Need & Provider Insurance & Billing Treatment & Diagnosis o"Enter data for Insurance & Billing by Patient Sort by Medical Provider Sort by Condition or Illness Sort for Medical History Medical History Open Script Dial Phone Sort by Date Sort by Patient Medical History Your Own ButtonB ReportsC View As ListD View As FormE CloseF Sort by Medical Provider Sort by Condition or Illness Sort for Medical History Open Script Dial Phone Cancel Specify Field Use Dialing Preferences Phone Number Field Value Number A List View Information Report Menu )=400 Cancel ER_DRAWH RIZRULER You did not enter any find criteria; all records will be displayed.C+ ) = 0 Cancel ER_DRAWH RIZRULER No records match this request.E+ ) = 1 Information List View Report Menu Sort by Date Sort by Patient Sort by Medical Provider Sort by Condition or Illness Sort for Medical History Medical History Open Script Dial Phone Sort by Date Sort by Patient Medical History #11#22122"3! "#""3"129 C3C3C34C4C3CC43C DDCD4DD4CDDC 4CDD4E4ET TEETEETUETUETUDUDEETUDTUE[ dUTeETeETeEUFTUTUFTUUTeK EUeFFEUFEUFFUeTeVFeUUdVEEk ffFdeefeefddfDeVdfEdfFdffk eVefefe VvffVefVVefUe\ fvfgfwffv ggvgvv gvwxgwghg vhgvvww Ejwwg wwxwwxw (LIST LISTA Claim Submitted VDEFA( (LIST VDEFA( Insurance Claim Submitted ListB Condition or Illness List wwwwww ffffff UUUUUU DDDDDD wwffeffg@ veUEDDCC vUTDD44 vUDDC32 #""# weUDD3 veTDC2233#3#2 wUDDC3##" wwwwww ffffff UUUUUU DDDDDD #4EWp "4EVx #3EVg "4DUg "#4DVg 24EVgy "34EVw ##4Efw ""3DUgw ""33DUfw ""34DVgx ""#34EVgx "#33DEfw " 234DUfw 2""2334DEVgx 3 4DEUfwx vUTD3#22 vUDDC fUD42233##3#"! vTDCC##" eUDC3223## fTD4C3##23#"" uTDC3323#2""! 22"2" ##2"! fTDD33#22"" vUDC32"2"" WUTC22 eTD3#"" GDC32"!! eD3#"! T32"" "%UR UD33D 3 DDUVgw D EUUfwx UDDEUUfgw U Vfgwx eUVfgww wwwwww ffffff UUUUUU DDDDDD 3333B """""" B"#B@ B"#B"$ 4"2$B"#B"#C 2$""#B"#C0 4"2#B"#C0 2$B"D0#C0 4""#C0 AD@D@ AD@D@ 44444 CCCCC 44444 CCCCC $42" bRBBP0 JJJJ !BBBB "99BB #9999 $9911 %1111 &))))C '!!!! *00**- *00-00 00*0) 00*&0# ## !0*!%00+#!*0##-0'"0*#%00.! @@BA@ UUUUU UUUUUU wwwwww (*)(%,3& )%+@6) ",30,)% #*>A6332+$"! 25,878 #&$690*" !)0,++)( "%/66435/'# +3;4*= !#,@9,)+,(""(-/,,*,1! !$&(265389,#!$$ '275? $*23/$ $),-..)'' !$&)(-5439@1!!&*-3/)!!%6B) )220(!$*.,,.' !$&*,*023:?B+*.,/3254.' "++,3/(.584.," !#&+/-./3:9@G@60/16883)! $++//'(9CD>4.$$ $%)*-//2693,.075-&)3792,$ ")-1347<>@G71(! **)&'*.0350+%(=A2'%)579<94( +/11! !%'),342)1?=0)" .1,$',-01)*).AG6-/048:<H /2583$%+66/% %)++*),+&%06,%$# !/40')-/31$$,@HFC<6887:==@B7%! 6A235,% +,/13.%#"(16+ !#$(04-$&+,+$ %2>D6,59:989889=0 ,.22<=33* .22671# !!&/42& *1$&+,/3779733, $$PQ /004B6* !$$ $))'/3) %&$&.7;4 )2$)*3-)466/%$ !),02+' %$5)%*+%$! (+'0:==4 $+,,1643"%)" !)/1)*+ +7=-%%&$! !3)3=. %&*/3113 !$$PQ ',4-%)/) ,6/%$$" +(!<- %),0354- .13-&,-* 14'$$! %))&%$! '3*$$" !&$%3 &%"%& 9836' )&#%%! $*)++" .-/:% !"&)()15, )" /.-+)!L //6B& #'*,.42$ $/,-*% IF1A1 "%.2/-*#! $/.,*($!#$"%PQ #57-*'$#"$&' ..//.-,)'(.212PQ ",,)&%'.;<6/+',,)%! '//,+//*)+.4:=>PQ $(&(),5?@:2/,,''*$ -!,,%.0%)./7 #43((+9CA=3+ &*)2!$96;;48@??PQ )/01%$ #3/').:@<3)$&)! /)4$%)8=A@?><@PQ !.0/.+//./1//* *.').3784/% ,,#%()25:<99=PQ %10//O 0 /+134,.25653." )++-! # %0,*,384'%PQ 42//11/&(/563135650( (./36$ !"23.,27- 6:=<)&931-13-!$.69433563+ ,/258 #$,96-37)$!P 38;?B>;63/.22.-068934673( ,638<6$ *),/6."')==138*$)PQ 35:=@B>953-/1.-368<:8995& %668:9( )$'*.:&$*==8/, -19=@CA>:83+2.,0157: !""/88$ !)*# 6/0%Q &' !$*38,.<;60" +07=@CD=6>@.*)&(*-03;@@<- 6.3/% #/23989=2,*% /039>B@ "9E7,)+/3667:?CE/!" $$%199207/ 9K8@) 3933" !0042381%$(.-)56PQ 556:=@@ 5C958=BGGA96;='"+- 94.6BDCFM='(204967& //2346% $59232$PQ :9<@?@C% 6D;;CJLONG952 (9304=FCDDE>% $,585' !.//11'$/;81$ 9:CE><D3,5G@@HF>IF94) $#%+*159C=:>FG) *31*# $/51# 89C=.!:9=C<9AFGS CA7&( /%3%!'+5A<6=C>$ -672.3<<961.%! ,,%=<9/69/02. "773//33/,+) /1$'9<3)" 069850(*)'% %/+$ !&##34 %0<PQ %"$:C9.*$ !+6@PQ "$$6CD>>5 !##() ".;CPQ %'0>GFA:378+&&%$$,& ,:CPQ 27CGG@6681//,)%$/ '7CPQ !%*/1,/44CC;6547@=2*!%.$ %;CPQ '$)=3 #%)*())3DLHB ?MB9/% ! "'6?6$ *;=PQ $%&,9D6 !$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ !)/38;@( "$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ +/0,$%&%%,26:5) "$%&(/7;<=BGIJIGMG=953'%(1<<63/! $*.8PQ 6=@?<3),3:8$ !&((),3=;::=EHIC:<F3)'""#&+/,', #&(0PQ FC8:CF@7/08<( "'()*,169?:6=C=2..3'" "%&)PQ HD99=A@9534/ !26(%5, ! !),''*-16<@=430/,+/)! ??979>@@:-! !$+%-*),/37<@:2/-*)+*" 4?=95;@@9& *#%.,/136884/,)'),,%)+(%$$ />C:13?@9)$ !!89+ !)$%*-/13321/, *3*)-/0/+&$$! 6A:0,8B=1+)/68.%/(,9=2% ")$"%)-02331/31)/().241+%##! *79/)/:<651/33)2<8.6=9. !$%,56643/75,'&).340+&#!$$%#! .5.)/46682%#$$-973:=<7[ !$'+4:964063+( ,33/+(&'),*)'# "%%.2379:1&"%(&.36@?@D5 !$%')/8:86>=2)&!!-231 34772+* &46339C@4+,3/)/:<D/8J=' "%'))+336@3(/)%#%,34569<=?CE5,)! #'21\ .7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,& #,0258<?ADGE2 "'(# "%),,/6983$ &4<9+4DD>?J>/*-6;<6,,/25.))3,' ",.0369;=AGE. !%%(,.040' 2A?EA4*+/683*.493/($!/-, 0246689:AC7% $%##(.23& :96,#"%)*(%(364,%"!!"560&)/<9;989;>3$ "03., PQ ~ffff ffffff ffff33 ff33ff ff3333 33ffff 33ff33 333333 wwwwww UUUUUU DDDDDD """""" Helvetica Geneva Times Times New Roman Arial MS Sans Serif Arial MT Condensed Light DateB FacilityB StreetB CityB StateB